{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Home","debt","2017_10","2017_12","2017_11","Help Page"],"not_rendered":{"charts":1,"images":19,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Home","index":0,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Home"]
[]
[]
[]
["TOTAL DEBT",{"$f":"debt!B2","v":-1425000}]
[]
[]
[]
["Total Bugdet",200]
["Remaining  Budget",185]
[]
[]
["                                          Last 5 Transactions of the Current Month"]
[1,"Food","2017-12-14",15,"Grocery"]
[2]
[3]
[4]
[5]
[]
[]
["Last # months average ",null,null,null,"Chart of Totals (Using total button)"]
["Grocery","3 Months",8.61,null,"2017_12","2017_11","2017_10"]
[null,null,null,null,15,5.41,5.41]
["Last # months total "]
["Grocery","3 Months",25.82]

{"sheet":"debt","index":1,"n_rows":106,"n_cols":7,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["DEBT"]
["Total Debt",{"$f":"SUM(G:G)","v":-1425000}]
[]
[]
["Total rows",{"$f":"COUNTA(A8:A34)","v":1}]
[]
["Sources","Debt ($)","Interest (montly %)","Minimum Payment (per month)","Months Left","Already Paid ($)","Balance ($)"]
["Car Loan",15000,0.04,100,24,0,{"$f":"B8-((B8*C8)*D8*E8)-F8","v":-1425000}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sources"]
["Debt"]
["Interest (mo)"]
["Minimum Payment"]
["Months Left"]
["Already Paid"]
["Balance"]

{"sheet":"2017_10","index":2,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Monthly Budget"]
[]
[null,null,null,null,null,null,null,null,"Total number of transactions:",{"$f":"COUNT(I5:I70)","v":3}]
["Expense","Budgeted","Used","Remaining",null,null,"Name","date","amount","category"]
["total Budget",{"$f":"SUM(B6:B22)","v":200},{"$f":"SUM(C6:C22)","v":50.769999999999996},{"$f":"B5-C5","v":149.23000000000002},null,null,"hello world!","2017-12-15",25.36,"Clothes"]
["Grocery",20,5.41,{"$f":"B6-C6","v":14.59},null,null,"legos","2017-12-12",50,"Fun money"]
["Car insurance",20,null,20,null,null,"lunch at CougarEat","2017-12-08",5.41,"Grocery"]
["Health insurance",20,null,20]
["Housing",10,null,10]
["Gas",10,null,10]
["Fun money",10,20,-10]
["Car maintenance",10,null,10]
["Medical",10,null,10]
["Clothes",10,25.36,-15.36]
["saving",10,null,10]
["charity",10,null,10]
["utlities",10,null,10]
["gifts",10,null,10]
["child care",10,null,10]
["education",10,null,10]
["recreation",10,null,10]
["debt",10]
["income","x",null,"x"]

{"sheet":"2017_12","index":3,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Monthly Budget","2017_12"]
[]
[null,null,null,null,null,null,null,null,"Total number of transactions:",{"$f":"COUNT(I5:I69)","v":1}]
["Expense","Budgeted","Used","Remaining",null,null,"Name","date","amount","category"]
["total Budget",{"$f":"SUM(B6:B22)","v":200},{"$f":"SUM(C6:C22)","v":15},{"$f":"B5-C5","v":185},null,null,"Food","2017-12-14",15,"Grocery"]
["Grocery",20,15,{"$f":"B6-C6","v":5}]
["Car insurance",20,null,20]
["Health insurance",20,null,20]
["Housing",10,null,10]
["Gas",10,null,10]
["Fun money",10,0,10]
["Car maintenance",10,null,10]
["Medical",10,null,10]
["Clothes",10,null,10]
["saving",10,null,10]
["charity",10,null,10]
["utlities",10,null,10]
["gifts",10,null,10]
["child care",10,null,10]
["education",10,null,10]
["recreation",10,null,10]
["debt",10,null,10]
["income","x",null,"x"]

{"sheet":"2017_11","index":4,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Monthly Budget"]
[]
[null,null,null,null,null,null,null,null,"Total number of transactions:",{"$f":"COUNT(I5:I70)","v":3}]
["Expense","Budgeted","Used","Remaining",null,null,"Name","date","amount","category"]
["total Budget",{"$f":"SUM(B6:B22)","v":200},{"$f":"SUM(C6:C22)","v":50.769999999999996},{"$f":"B5-C5","v":149.23000000000002},null,null,"hello world!","2017-12-15",25.36,"Clothes"]
["Grocery",20,5.41,{"$f":"B6-C6","v":14.59},null,null,"legos","2017-12-12",50,"Fun money"]
["Car insurance",20,null,20,null,null,"lunch at CougarEat","2017-12-08",5.41,"Grocery"]
["Health insurance",20,null,20]
["Housing",10,null,10]
["Gas",10,null,10]
["Fun money",10,20,-10]
["Car maintenance",10,null,10]
["Medical",10,null,10]
["Clothes",10,25.36,-15.36]
["saving",10,null,10]
["charity",10,null,10]
["utlities",10,null,10]
["gifts",10,null,10]
["child care",10,null,10]
["education",10,null,10]
["recreation",10,null,10]
["debt",10]
["income","x",null,"x"]

{"sheet":"Help Page","index":5,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["QUICK GUIDE"]
["HOME","1. There are buttons at the top of the page to switch between sheets."]
[null,"2. The \"Create New Month\" button will only work for the current month. You will not be able to create a new page for February if it is still January"]
[null,"3. The Net worth of your account includes the savings and subtracts any existing debts"]
[null,"4. After clicking on the \"Find Averages\" button, a window will appear. Select an amount of months and a category. The average expenses on the information given will then appear on the chart above."]
[null,"5. The \"Find Totals\" button works in a similar manner as the \"Find Averages\" button to find the total expenses except this one will also update the graph on the right side of the page. "]
[null,"6. The \"Last 5 Transactions\" chart will update automatically as expenses are entered in the current month page"]
[]
["DEBT","1.To add a source, click on the \"Add Source\" button and a window will show up in which the information about the debt will be entered. The Chart will then be updated with the new source. "]
[null,"2. To delete a source, click on the \"Delete Source\" button and a window will show up with a list of all the sources. Select the desired source and then click \"OK.\""]
[null,"3. The \"Sort debt by…\" button will show a window with available options such as interest and balance. It will always sort the chart from lowest to highest."]
[null,"4. There is a cell with the total debt at the top left corner"]
[]
["MONTHLY BUDGET","1. The Used and the Budgeted values are to be entered and the Remaining value will be automatically updated"]
[null,"2. To add an expense, click on the \"Add an expense…\" button. A window will appear asking for details about the expense. After entering these detail, click \"OK\" and the blue chart on the right will be updated."]
[null,"3. To delete an expense, click on the \"Delete an expense…\" button. A window will appear with a list of all the expenses. Select the desired expense and clikc \"OK.\""]
[null,"4. Clicking on each of the section titles(written in white) on the blue chart will reorganize the chart. (Alphabetically, most recent to oldest, or lowest value to highest depending on which title was selected)"]